| Number of Variables | 24 |
|---|---|
| Number of Rows | 844338 |
| Missing Cells | 1.6887e+06 |
| Missing Cells (%) | 8.3% |
| Duplicate Rows | 0 |
| Duplicate Rows (%) | 0.0% |
| Total Size in Memory | 245.3 MB |
| Average Row Size in Memory | 304.6 B |
| Variable Types |
|
| assortment has 844338 (100.0%) missing values | Missing |
|---|---|
| state_holiday has 844338 (100.0%) missing values | Missing |
| competition_distance is skewed | Skewed |
| competition_open_since_year is skewed | Skewed |
| sales is skewed | Skewed |
| competition_time_month is skewed | Skewed |
| promo_time_week is skewed | Skewed |
| store_type has constant length 1 | Constant Length |
| promo2 has constant length 1 | Constant Length |
| promo2_since_year has constant length 4 | Constant Length |
| day_of_week has constant length 1 | Constant Length |
|---|---|
| promo has constant length 1 | Constant Length |
| school_holiday has constant length 1 | Constant Length |
| is_promo has constant length 1 | Constant Length |
| year has constant length 4 | Constant Length |
| dayofweek has constant length 1 | Constant Length |
| assortment has all distinct values | Unique |
| state_holiday has all distinct values | Unique |
| competition_time_month has 70101 (8.3%) negatives | Negatives |
| promo_time_week has 57241 (6.78%) negatives | Negatives |
| competition_time_month has 268025 (31.74%) zeros | Zeros |
|---|---|
| promo_time_week has 421646 (49.94%) zeros | Zeros |
numerical
| Approximate Distinct Count | 1115 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 558.4214 |
| Minimum | 1 |
| Maximum | 1115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 56 |
| Q1 | 280 |
| Median | 558 |
| Q3 | 837 |
| 95-th Percentile | 1060 |
| Maximum | 1115 |
| Range | 1114 |
| IQR | 557 |
| Mean | 558.4214 |
|---|---|
| Standard Deviation | 321.7309 |
| Variance | 103510.7472 |
| Sum | 4.715e+08 |
| Skewness | 0.00042588 |
| Kurtosis | -1.1988 |
| Coefficient of Variation | 0.5761 |
categorical
| Approximate Distinct Count | 4 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | c |
|---|---|
| 2nd row | c |
| 3rd row | c |
| 4th row | c |
| 5th row | c |
| Count | 844338 |
|---|---|
| Lowercase Letter | 844338 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 1 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 54.8 MB |
| Mean | 3 |
|---|---|
| Standard Deviation | 0 |
| Median | 3 |
| Minimum | 3 |
| Maximum | 3 |
| 1st row | nan |
|---|---|
| 2nd row | nan |
| 3rd row | nan |
| 4th row | nan |
| 5th row | nan |
| Count | 2533014 |
|---|---|
| Lowercase Letter | 2533014 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
numerical
| Approximate Distinct Count | 655 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 5961.8275 |
| Minimum | 20 |
| Maximum | 200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 20 |
|---|---|
| 5-th Percentile | 140 |
| Q1 | 720 |
| Median | 2340 |
| Q3 | 6930 |
| 95-th Percentile | 21790 |
| Maximum | 200000 |
| Range | 199980 |
| IQR | 6210 |
| Mean | 5961.8275 |
|---|---|
| Standard Deviation | 12592.1811 |
| Variance | 1.5856e+08 |
| Sum | 5.0338e+09 |
| Skewness | 10.1349 |
| Kurtosis | 145.2878 |
| Coefficient of Variation | 2.1121 |
numerical
| Approximate Distinct Count | 12 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 6.7874 |
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 2 |
| Q1 | 4 |
| Median | 7 |
| Q3 | 10 |
| 95-th Percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| IQR | 6 |
| Mean | 6.7874 |
|---|---|
| Standard Deviation | 3.3099 |
| Variance | 10.9555 |
| Sum | 5.7308e+06 |
| Skewness | -0.04845 |
| Kurtosis | -1.2319 |
| Coefficient of Variation | 0.4877 |
numerical
| Approximate Distinct Count | 23 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 2010.3311 |
| Minimum | 1900 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1900 |
|---|---|
| 5-th Percentile | 2002 |
| Q1 | 2008 |
| Median | 2012 |
| Q3 | 2014 |
| 95-th Percentile | 2015 |
| Maximum | 2015 |
| Range | 115 |
| IQR | 6 |
| Mean | 2010.3311 |
|---|---|
| Standard Deviation | 5.5026 |
| Variance | 30.2789 |
| Sum | 1.6974e+09 |
| Skewness | -7.2173 |
| Kurtosis | 123.9023 |
| Coefficient of Variation | 0.002737 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
numerical
| Approximate Distinct Count | 52 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 23.6291 |
| Minimum | 1 |
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 3 |
| Q1 | 12 |
| Median | 22 |
| Q3 | 37 |
| 95-th Percentile | 47 |
| Maximum | 52 |
| Range | 51 |
| IQR | 25 |
| Mean | 23.6291 |
|---|---|
| Standard Deviation | 14.2883 |
| Variance | 204.1559 |
| Sum | 1.9951e+07 |
| Skewness | 0.1704 |
| Kurtosis | -1.1948 |
| Coefficient of Variation | 0.6047 |
categorical
| Approximate Distinct Count | 7 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 55.6 MB |
| Mean | 4 |
|---|---|
| Standard Deviation | 0 |
| Median | 4 |
| Minimum | 4 |
| Maximum | 4 |
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3377352 |
categorical
| Approximate Distinct Count | 7 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 5 |
|---|---|
| 2nd row | 4 |
| 3rd row | 3 |
| 4th row | 2 |
| 5th row | 1 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
datetime
| Distinct Count | 941.7339 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 12.9 MB |
| Minimum | 2013-01-01 00:00:00 |
| Maximum | 2015-07-31 00:00:00 |
numerical
| Approximate Distinct Count | 21733 |
|---|---|
| Approximate Unique (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 6955.9591 |
| Minimum | 46 |
| Maximum | 41551 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 46 |
|---|---|
| 5-th Percentile | 3240 |
| Q1 | 4877 |
| Median | 6397 |
| Q3 | 8388 |
| 95-th Percentile | 12905 |
| Maximum | 41551 |
| Range | 41505 |
| IQR | 3511 |
| Mean | 6955.9591 |
|---|---|
| Standard Deviation | 3103.8155 |
| Variance | 9.6337e+06 |
| Sum | 5.8732e+09 |
| Skewness | 1.5949 |
| Kurtosis | 4.854 |
| Coefficient of Variation | 0.4462 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
categorical
| Approximate Distinct Count | 1 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 54.8 MB |
| Mean | 3 |
|---|---|
| Standard Deviation | 0 |
| Median | 3 |
| Minimum | 3 |
| Maximum | 3 |
| 1st row | nan |
|---|---|
| 2nd row | nan |
| 3rd row | nan |
| 4th row | nan |
| 5th row | nan |
| Count | 2533014 |
|---|---|
| Lowercase Letter | 2533014 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
categorical
| Approximate Distinct Count | 3 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 55.6 MB |
| Mean | 4 |
|---|---|
| Standard Deviation | 0 |
| Median | 4 |
| Minimum | 4 |
| Maximum | 4 |
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3377352 |
numerical
| Approximate Distinct Count | 12 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 5.8458 |
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 1 |
| Q1 | 3 |
| Median | 6 |
| Q3 | 8 |
| 95-th Percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| IQR | 5 |
| Mean | 5.8458 |
|---|---|
| Standard Deviation | 3.324 |
| Variance | 11.0487 |
| Sum | 4.9358e+06 |
| Skewness | 0.2577 |
| Kurtosis | -1.0332 |
| Coefficient of Variation | 0.5686 |
numerical
| Approximate Distinct Count | 52 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 23.6469 |
| Minimum | 1 |
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 3 |
| Q1 | 11 |
| Median | 23 |
| Q3 | 35 |
| 95-th Percentile | 49 |
| Maximum | 52 |
| Range | 51 |
| IQR | 24 |
| Mean | 23.6469 |
|---|---|
| Standard Deviation | 14.3899 |
| Variance | 207.0701 |
| Sum | 1.9966e+07 |
| Skewness | 0.2623 |
| Kurtosis | -1.0258 |
| Coefficient of Variation | 0.6085 |
categorical
| Approximate Distinct Count | 7 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 53.1 MB |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 4 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 1 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 844338 |
categorical
| Approximate Distinct Count | 4 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 56.9 MB |
| Mean | 5.6279 |
|---|---|
| Standard Deviation | 0.7783 |
| Median | 6 |
| Minimum | 4 |
| Maximum | 6 |
| 1st row | summer |
|---|---|
| 2nd row | summer |
| 3rd row | summer |
| 4th row | summer |
| 5th row | summer |
| Count | 4751878 |
|---|---|
| Lowercase Letter | 4751878 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
numerical
| Approximate Distinct Count | 376 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 41.6797 |
| Minimum | -32 |
| Maximum | 1407 |
| Zeros | 268025 |
| Zeros (%) | 31.7% |
| Negatives | 70101 |
| Negatives (%) | 8.3% |
| Minimum | -32 |
|---|---|
| 5-th Percentile | -6 |
| Q1 | 0 |
| Median | 17 |
| Q3 | 75 |
| 95-th Percentile | 149 |
| Maximum | 1407 |
| Range | 1439 |
| IQR | 75 |
| Mean | 41.6797 |
|---|---|
| Standard Deviation | 66.8144 |
| Variance | 4464.1657 |
| Sum | 3.5192e+07 |
| Skewness | 7.3388 |
| Kurtosis | 126.8551 |
| Coefficient of Variation | 1.603 |
datetime
| Distinct Count | 167.2131 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 12.9 MB |
| Minimum | 2009-07-27 00:00:00 |
| Maximum | 2015-07-27 00:00:00 |
numerical
| Approximate Distinct Count | 440 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 12.9 MB |
| Mean | 54.4007 |
| Minimum | -126 |
| Maximum | 313 |
| Zeros | 421646 |
| Zeros (%) | 49.9% |
| Negatives | 57241 |
| Negatives (%) | 6.8% |
| Minimum | -126 |
|---|---|
| 5-th Percentile | -16 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 111 |
| 95-th Percentile | 233 |
| Maximum | 313 |
| Range | 439 |
| IQR | 111 |
| Mean | 54.4007 |
|---|---|
| Standard Deviation | 85.4576 |
| Variance | 7302.9944 |
| Sum | 4.5933e+07 |
| Skewness | 1.1034 |
| Kurtosis | 0.113 |
| Coefficient of Variation | 1.5709 |